Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# WORKAREA_SIZE_POLICY

Property | Description
--- | ---
Parameter type | String
Syntax | `WORKAREA_SIZE_POLICY = { AUTO | MANUAL }`
Default value | `AUTO`
Modifiable | `ALTER SESSION`, `ALTER SYSTEM`

`WORKAREA_SIZE_POLICY` specifies the policy for sizing work areas. This parameter controls the mode in which working areas are tuned.

Values:

- `AUTO`

  Work areas used by memory-intensive operators are sized automatically, based on the PGA memory used by the system, the target PGA memory set in `PGA_AGGREGATE_TARGET`, and the requirement of each individual operator.

- `MANUAL`

  The sizing of work areas is manual and based on the values of the *`_AREA_SIZE` parameter corresponding to the operation (for example, a sort uses `SORT_AREA_SIZE`). Specifying `MANUAL` may result in sub-optimal performance and poor PGA memory utilization.